package com.czxy.dao;

import com.czxy.pojo.SpecificationOption;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/**
 * 规格选项类
 * @author Liuyunqin 17674029449@163.com
 * @date 2018/12/25 15:05
 */
@org.apache.ibatis.annotations.Mapper
public interface SpecificationOptionMapper extends Mapper<SpecificationOption> {

    /**
     * 根据规格id 查询 对应的规格选项
     * @param specId
     * @return
     */
    @Select("SELECT * FROM tb_specification_option WHERE spec_id=#{specId}")
    public List<SpecificationOption> findSpecificationOptionBySpecId(@Param("specId") Integer specId);


}
